Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2172
Missing cells	429
Missing cells (%)	1.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	203.8 KiB
Average record size in memory	96.1 B

Variable types

Numeric	11
Categorical	1

Warnings

`Year` has constant value "0.0"	Constant
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `HIGH_2` and 2 other fields	High correlation
`LF_4` is highly correlated with `HIGH_6`	High correlation
`HIGH_2` is highly correlated with `Houses - median sale price ($)` and 3 other fields	High correlation
`HIGH_4` is highly correlated with `Houses - median sale price ($)` and 2 other fields	High correlation
`HIGH_5` is highly correlated with `Houses - median sale price ($)` and 3 other fields	High correlation
`HIGH_6` is highly correlated with `LF_4` and 2 other fields	High correlation
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `HIGH_2` and 3 other fields	High correlation
`LF_3` is highly correlated with `LF_4`	High correlation
`LF_4` is highly correlated with `LF_3`	High correlation
`HIGH_2` is highly correlated with `Houses - median sale price ($)` and 3 other fields	High correlation
`HIGH_4` is highly correlated with `Houses - median sale price ($)` and 2 other fields	High correlation
`HIGH_5` is highly correlated with `Houses - median sale price ($)` and 3 other fields	High correlation
`HIGH_6` is highly correlated with `Houses - median sale price ($)` and 2 other fields	High correlation
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `HIGH_2` and 1 other fields	High correlation
`HIGH_2` is highly correlated with `Houses - median sale price ($)` and 2 other fields	High correlation
`HIGH_4` is highly correlated with `HIGH_2` and 1 other fields	High correlation
`HIGH_5` is highly correlated with `Houses - median sale price ($)` and 2 other fields	High correlation
`LF_4` is highly correlated with `HIGH_6` and 1 other fields	High correlation
`HIGH_3` is highly correlated with `HIGH_5` and 5 other fields	High correlation
`HIGH_6` is highly correlated with `LF_4` and 3 other fields	High correlation
`HIGH_5` is highly correlated with `HIGH_3` and 6 other fields	High correlation
`HIGH_4` is highly correlated with `HIGH_3` and 5 other fields	High correlation
`HIGH_2` is highly correlated with `LF_4` and 7 other fields	High correlation
`df_index` is highly correlated with `HIGH_3` and 5 other fields	High correlation
`Houses - median sale price ($)` is highly correlated with `HIGH_3` and 5 other fields	High correlation
`ASGS_2016` is highly correlated with `HIGH_3` and 5 other fields	High correlation
`HIGH_7` is highly correlated with `ASGS_2016`	High correlation
`Houses - median sale price ($)` has 388 (17.9%) missing values	Missing
`HIGH_7` has 40 (1.8%) missing values	Missing
`df_index` has unique values	Unique
`ASGS_2016` has unique values	Unique

Reproduction

Analysis started	2021-08-19 05:15:40.276183
Analysis finished	2021-08-19 05:16:03.689680
Duration	23.41 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2172
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	-1.720800851
Maximum	1.783358168
Zeros	0
Zeros (%)	0.0%
Negative	1093
Negative (%)	50.3%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.720800851
5-th percentile	-1.55171103
Q1	-0.8615859539
median	-0.01001871973
Q3	0.8522552422
95-th percentile	1.571441436
Maximum	1.783358168
Range	3.504159019
Interquartile range (IQR)	1.713841196

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	nan
Kurtosis	-1.177481652
Mean	0
Median Absolute Deviation (MAD)	0.8573029812
Skewness	0.02138564561
Sum	0
Variance	1.000460617
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6270315776	1	< 0.1%
1.165427027	1	< 0.1%
-1.433248736	1	< 0.1%
1.04000536	1	< 0.1%
0.8534023916	1	< 0.1%
0.3517157228	1	< 0.1%
0.9711763961	1	< 0.1%
-0.8459082455	1	< 0.1%
1.174604222	1	< 0.1%
0.3731291782	1	< 0.1%
Other values (2162)	2162	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.720800851	1	< 0.1%
-1.719271318	1	< 0.1%
-1.717741786	1	< 0.1%
-1.716212253	1	< 0.1%
-1.714682721	1	< 0.1%
-1.713153188	1	< 0.1%
-1.711623656	1	< 0.1%
-1.710094123	1	< 0.1%
-1.708564591	1	< 0.1%
-1.707035058	1	< 0.1%

Value	Count	Frequency (%)
1.783358168	1	< 0.1%
1.781828635	1	< 0.1%
1.780299103	1	< 0.1%
1.77876957	1	< 0.1%
1.775710505	1	< 0.1%
1.774180973	1	< 0.1%
1.768062842	1	< 0.1%
1.765003777	1	< 0.1%
1.763474245	1	< 0.1%
1.761944712	1	< 0.1%

ASGS_2016
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2172
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-2.093680253 × 10^-16

Minimum	-1.115755843
Maximum	3.065573447
Zeros	0
Zeros (%)	0.0%
Negative	1387
Negative (%)	63.9%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.115755843
5-th percentile	-1.089674907
Q1	-0.9746887552
median	-0.05482193222
Q3	0.4731101426
95-th percentile	2.02551762
Maximum	3.065573447
Range	4.181329291
Interquartile range (IQR)	1.447798898

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	-4.777378402 × 10¹⁵
Kurtosis	0.2524799437
Mean	-2.093680253 × 10^-16
Median Absolute Deviation (MAD)	0.5382546525
Skewness	0.9872188556
Sum	-4.547473509 × 10^-13
Variance	1.000460617
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01312487545	1	< 0.1%
0.4731101518	1	< 0.1%
-0.5302251901	1	< 0.1%
-0.5406792241	1	< 0.1%
-0.5408361037	1	< 0.1%
-0.5302256866	1	< 0.1%
2.542920946	1	< 0.1%
-0.9798633828	1	< 0.1%
2.025337203	1	< 0.1%
-1.089518036	1	< 0.1%
Other values (2162)	2162	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.115755843	1	< 0.1%
-1.115755838	1	< 0.1%
-1.115755833	1	< 0.1%
-1.115755827	1	< 0.1%
-1.115755822	1	< 0.1%
-1.115755817	1	< 0.1%
-1.115703546	1	< 0.1%
-1.115703541	1	< 0.1%
-1.115703536	1	< 0.1%
-1.115703531	1	< 0.1%

Value	Count	Frequency (%)
3.065573447	1	< 0.1%
3.065521177	1	< 0.1%
3.065468906	1	< 0.1%
3.065416636	1	< 0.1%
2.543286919	1	< 0.1%
2.543234648	1	< 0.1%
2.543234627	1	< 0.1%
2.543182231	1	< 0.1%
2.543182226	1	< 0.1%
2.543182221	1	< 0.1%

Year
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	127.4 KiB

0.0	2172

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	6516
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	2172	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0.0	2172	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	4344	66.7%
.	2172	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4344	66.7%
Other Punctuation	2172	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4344	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	2172	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6516	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4344	66.7%
.	2172	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6516	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4344	66.7%
.	2172	33.3%

Houses - median sale price ($)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	907
Distinct (%)	50.8%
Missing	388
Missing (%)	17.9%
Infinite	0
Infinite (%)	0.0%
Mean	4.779435442 × 10^-17

Minimum	-1.232746921
Maximum	8.203826913
Zeros	0
Zeros (%)	0.0%
Negative	1166
Negative (%)	53.7%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.232746921
5-th percentile	-0.9099667295
Q1	-0.5972385163
median	-0.239834844
Q3	0.2245107083
95-th percentile	1.916537875
Maximum	8.203826913
Range	9.436573834
Interquartile range (IQR)	0.8217492246

Descriptive statistics

Standard deviation	1.000280387
Coefficient of variation (CV)	2.09288398 × 10¹⁶
Kurtosis	14.47398449
Mean	4.779435442 × 10^-17
Median Absolute Deviation (MAD)	0.3797414018
Skewness	3.054097813
Sum	8.526512829 × 10^-14
Variance	1.000560852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.6419139753	15	0.7%
-0.3515234916	15	0.7%
-0.5972385163	15	0.7%
-0.5078875982	14	0.6%
-0.4520432744	14	0.6%
-0.608407381	13	0.6%
-0.7536026229	13	0.6%
-0.195159385	11	0.5%
-0.2845103031	11	0.5%
-0.2286659793	11	0.5%
Other values (897)	1652	76.1%
(Missing)	388	17.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.232746921	1	< 0.1%
-1.189188348	1	< 0.1%
-1.185279246	1	< 0.1%
-1.172435051	1	< 0.1%
-1.166850619	1	< 0.1%
-1.146746662	1	< 0.1%
-1.135577798	2	0.1%
-1.134460911	1	< 0.1%
-1.1188245	1	< 0.1%
-1.116590728	1	< 0.1%

Value	Count	Frequency (%)
8.203826913	1	< 0.1%
8.069800536	2	0.1%
7.623045946	1	< 0.1%
6.729536765	1	< 0.1%
5.953300664	1	< 0.1%
5.791352125	1	< 0.1%
5.054207051	1	< 0.1%
4.858751918	1	< 0.1%
4.763816568	1	< 0.1%
4.607452461	1	< 0.1%

LF_3
Real number (ℝ)

HIGH CORRELATION

Distinct	802
Distinct (%)	36.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.925650474 × 10^-17

Minimum	-1.349623832
Maximum	9.215684801
Zeros	0
Zeros (%)	0.0%
Negative	1270
Negative (%)	58.5%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.349623832
5-th percentile	-1.100762173
Q1	-0.7764878893
median	-0.2410582583
Q3	0.5026987467
95-th percentile	1.949678471
Maximum	9.215684801
Range	10.56530863
Interquartile range (IQR)	1.279186636

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	2.547935148 × 10¹⁶
Kurtosis	4.573269343
Mean	3.925650474 × 10^-17
Median Absolute Deviation (MAD)	0.6033009926
Skewness	1.494104742
Sum	8.526512829 × 10^-14
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.4031954001	11	0.5%
-0.4409017121	11	0.5%
-0.6482864284	10	0.5%
-0.7538641021	10	0.5%
-0.7764878893	10	0.5%
-0.9235425063	10	0.5%
-0.9386250311	10	0.5%
-1.032890811	9	0.4%
-1.05928523	9	0.4%
-1.085679648	9	0.4%
Other values (792)	2073	95.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.349623832	4	0.2%
-1.338311939	1	< 0.1%
-1.334541308	1	< 0.1%
-1.327000045	1	< 0.1%
-1.31191752	2	0.1%
-1.300605627	2	0.1%
-1.293064364	2	0.1%
-1.289293733	1	< 0.1%
-1.285523102	1	< 0.1%
-1.277981839	2	0.1%

Value	Count	Frequency (%)
9.215684801	1	< 0.1%
4.777651874	1	< 0.1%
4.547643371	1	< 0.1%
4.525019584	1	< 0.1%
4.423212541	1	< 0.1%
4.23091035	1	< 0.1%
4.196974669	1	< 0.1%
4.01221374	1	< 0.1%
3.948113009	1	< 0.1%
3.797287761	1	< 0.1%

LF_4
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	167
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-2.878810347 × 10^-16

Minimum	-1.614003279
Maximum	12.92939607
Zeros	0
Zeros (%)	0.0%
Negative	1325
Negative (%)	61.0%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.614003279
5-th percentile	-0.9581244848
Q1	-0.5874103838
median	-0.1881798134
Q3	0.2966001649
95-th percentile	1.551324815
Maximum	12.92939607
Range	14.54339935
Interquartile range (IQR)	0.8840105487

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	-3.47445702 × 10¹⁵
Kurtosis	37.6204057
Mean	-2.878810347 × 10^-16
Median Absolute Deviation (MAD)	0.4277470397
Skewness	4.366645876
Sum	-6.252776075 × 10^-13
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2166962827	52	2.4%
-0.1596633441	48	2.2%
-0.4163115679	48	2.2%
-0.5018609758	45	2.1%
-0.5303774451	44	2.0%
-0.6444433224	44	2.0%
-0.4448280372	43	2.0%
0.03995194112	43	2.0%
-0.5874103838	42	1.9%
-0.3307621599	41	1.9%
Other values (157)	1722	79.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.614003279	1	< 0.1%
-1.55697034	1	< 0.1%
-1.528453871	1	< 0.1%
-1.471420932	2	0.1%
-1.442904463	1	< 0.1%
-1.414387994	2	0.1%
-1.385871525	1	< 0.1%
-1.357355055	3	0.1%
-1.328838586	3	0.1%
-1.300322117	4	0.2%

Value	Count	Frequency (%)
12.92939607	1	< 0.1%
10.96175969	1	< 0.1%
10.90472675	1	< 0.1%
10.19181502	1	< 0.1%
8.765991551	1	< 0.1%
6.570223414	1	< 0.1%
6.427641067	2	0.1%
6.113959905	1	< 0.1%
5.88582815	1	< 0.1%
5.258465825	1	< 0.1%

HIGH_2
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	573
Distinct (%)	26.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.05650549 × 10^-16

Minimum	-2.550450043
Maximum	2.844077604
Zeros	0
Zeros (%)	0.0%
Negative	1133
Negative (%)	52.2%
Memory size	17.1 KiB

Quantile statistics

Minimum	-2.550450043
5-th percentile	-1.426872139
Q1	-0.851546104
median	-0.06301100873
Q3	0.7745960131
95-th percentile	1.703239919
Maximum	2.844077604
Range	5.394527648
Interquartile range (IQR)	1.626142117

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	2.465743692 × 10¹⁵
Kurtosis	-0.8914402206
Mean	4.05650549 × 10^-16
Median Absolute Deviation (MAD)	0.8088407201
Skewness	0.2056678441
Sum	8.810729923 × 10^-13
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.6755640227	11	0.5%
0.06897555229	11	0.5%
-1.196741725	11	0.5%
-0.9327686031	11	0.5%
-0.9056944368	9	0.4%
1.084256791	9	0.4%
-1.034296727	9	0.4%
-0.5604988156	9	0.4%
-0.5131190245	9	0.4%
-0.9733798527	9	0.4%
Other values (563)	2074	95.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.550450043	1	< 0.1%
-2.313551088	1	< 0.1%
-2.266171296	1	< 0.1%
-2.232328589	1	< 0.1%
-2.198485881	1	< 0.1%
-2.191717339	1	< 0.1%
-2.171411714	1	< 0.1%
-2.164643173	1	< 0.1%
-2.151106089	1	< 0.1%
-2.117263381	1	< 0.1%

Value	Count	Frequency (%)
2.844077604	1	< 0.1%
2.566567399	1	< 0.1%
2.424428026	1	< 0.1%
2.214603236	2	0.1%
2.194297612	1	< 0.1%
2.167223445	1	< 0.1%
2.153686362	1	< 0.1%
2.133380737	1	< 0.1%
2.106306571	3	0.1%
2.086000946	1	< 0.1%

HIGH_3
Real number (ℝ)

HIGH CORRELATION

Distinct	211
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.57026019 × 10^-16

Minimum	-1.939224627
Maximum	3.22632218
Zeros	0
Zeros (%)	0.0%
Negative	1362
Negative (%)	62.7%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.939224627
5-th percentile	-1.22755213
Q1	-0.6760341412
median	-0.270008628
Q3	0.4743714796
95-th percentile	2.053359587
Maximum	3.22632218
Range	5.165546807
Interquartile range (IQR)	1.150405621

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	-6.36983787 × 10¹⁵
Kurtosis	0.5998284352
Mean	-1.57026019 × 10^-16
Median Absolute Deviation (MAD)	0.518810378
Skewness	1.060748243
Sum	-3.410605132 × 10^-13
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.3827934927	39	1.8%
-0.4053504657	36	1.7%
-0.4730213846	36	1.7%
-0.4279074387	34	1.6%
-0.3376795468	34	1.6%
-0.1572237632	34	1.6%
-0.5181353305	34	1.6%
-0.6534771682	33	1.5%
-0.5858062494	33	1.5%
-0.6309201953	33	1.5%
Other values (201)	1826	84.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.939224627	1	< 0.1%
-1.73621187	1	< 0.1%
-1.691097924	1	< 0.1%
-1.668540951	1	< 0.1%
-1.623427005	1	< 0.1%
-1.600870032	1	< 0.1%
-1.555756087	3	0.1%
-1.533199114	3	0.1%
-1.510642141	1	< 0.1%
-1.465528195	8	0.4%

Value	Count	Frequency (%)
3.22632218	1	< 0.1%
3.181208235	1	< 0.1%
3.158651262	2	0.1%
3.136094289	2	0.1%
3.06842337	1	< 0.1%
3.045866397	1	< 0.1%
3.023309424	2	0.1%
2.978195478	4	0.2%
2.955638505	3	0.1%
2.933081532	3	0.1%

HIGH_4
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	357
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-5.234200632 × 10^-17

Minimum	-2.392584478
Maximum	2.63359091
Zeros	0
Zeros (%)	0.0%
Negative	1107
Negative (%)	51.0%
Memory size	17.1 KiB

Quantile statistics

Minimum	-2.392584478
5-th percentile	-1.588876241
Q1	-0.7851680053
median	-0.02944235045
Q3	0.7982571763
95-th percentile	1.613961058
Maximum	2.63359091
Range	5.026175387
Interquartile range (IQR)	1.583425182

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	-1.910951361 × 10¹⁶
Kurtosis	-0.8398612335
Mean	-5.234200632 × 10^-17
Median Absolute Deviation (MAD)	0.7917125908
Skewness	0.06053058004
Sum	-1.136868377 × 10^-13
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.06652281208	17	0.8%
-0.1733900942	16	0.7%
0.006544585497	15	0.7%
-0.02944235045	15	0.7%
0.5463486247	15	0.7%
1.110143955	14	0.6%
0.09051410271	14	0.6%
-0.08942057703	14	0.6%
-0.05343364108	14	0.6%
0.1265010387	14	0.6%
Other values (347)	2024	93.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.392584478	1	< 0.1%
-2.224645443	1	< 0.1%
-2.188658507	1	< 0.1%
-2.164667217	1	< 0.1%
-2.128680281	2	0.1%
-2.080697699	1	< 0.1%
-2.068702054	2	0.1%
-2.044710763	1	< 0.1%
-1.996728182	1	< 0.1%
-1.984732537	3	0.1%

Value	Count	Frequency (%)
2.63359091	1	< 0.1%
2.489643166	1	< 0.1%
2.465651875	1	< 0.1%
2.333699777	1	< 0.1%
2.321704131	1	< 0.1%
2.261725905	2	0.1%
2.24973026	1	< 0.1%
2.237734614	1	< 0.1%
2.213743324	1	< 0.1%
2.177756388	1	< 0.1%

HIGH_5
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	129
Distinct (%)	5.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.618305797 × 10^-17

Minimum	-2.135829557
Maximum	3.482352763
Zeros	0
Zeros (%)	0.0%
Negative	1187
Negative (%)	54.7%
Memory size	17.1 KiB

Quantile statistics

Minimum	-2.135829557
5-th percentile	-1.481657643
Q1	-0.7505243275
median	-0.1348331143
Q3	0.6347809021
95-th percentile	1.827682628
Maximum	3.482352763
Range	5.61818232
Interquartile range (IQR)	1.38530523

Descriptive statistics

Standard deviation	1.000230388
Coefficient of variation (CV)	3.820143504 × 10¹⁶
Kurtosis	-0.2743590457
Mean	2.618305797 × 10^-17
Median Absolute Deviation (MAD)	0.6926526148
Skewness	0.4994493924
Sum	5.684341886 × 10^-14
Variance	1.000460829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.1733138151	44	2.0%
-0.7120436266	43	2.0%
0.01908968898	41	1.9%
-0.3272366184	41	1.9%
-0.9044471308	37	1.7%
-0.4041980201	37	1.7%
0.05757038981	37	1.7%
-0.3657173192	36	1.7%
-0.2887559176	36	1.7%
-0.5581208234	36	1.7%
Other values (119)	1783	82.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.135829557	1	< 0.1%
-1.981906754	3	0.1%
-1.943426053	1	< 0.1%
-1.904945352	1	< 0.1%
-1.866464651	1	< 0.1%
-1.827983951	6	0.3%
-1.78950325	3	0.1%
-1.751022549	7	0.3%
-1.712541848	11	0.5%
-1.674061147	8	0.4%

Value	Count	Frequency (%)
3.482352763	1	< 0.1%
3.366910661	1	< 0.1%
3.32842996	1	< 0.1%
3.289949259	1	< 0.1%
3.020584353	2	0.1%
2.828180849	1	< 0.1%
2.674258046	2	0.1%
2.635777345	1	< 0.1%
2.597296644	1	< 0.1%
2.558815943	4	0.2%

HIGH_6
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	137
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-6.54275079 × 10^-18

Minimum	-1.765924779
Maximum	11.69777108
Zeros	0
Zeros (%)	0.0%
Negative	1219
Negative (%)	56.1%
Memory size	17.1 KiB

Quantile statistics

Minimum	-1.765924779
5-th percentile	-1.256487638
Q1	-0.7470504977
median	-0.1284482556
Q3	0.5265423537
95-th percentile	1.707344869
Maximum	11.69777108
Range	13.46369586
Interquartile range (IQR)	1.273592851

Descriptive statistics

Standard deviation	1.000230282
Coefficient of variation (CV)	-1.528761089 × 10¹⁷
Kurtosis	12.6913433
Mean	-6.54275079 × 10^-18
Median Absolute Deviation (MAD)	0.6186022421
Skewness	1.944662053
Sum	-1.421085472 × 10^-14
Variance	1.000460617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.05567152125	49	2.3%
0.08988194748	44	2.0%
-0.09205988843	43	2.0%
-0.9289923336	42	1.9%
-0.20122499	39	1.8%
-0.3831668259	38	1.7%
-0.6742737634	38	1.7%
-0.7470504977	38	1.7%
0.1626586818	38	1.7%
-0.2740017243	37	1.7%
Other values (127)	1766	81.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.765924779	1	< 0.1%
-1.656759677	3	0.1%
-1.62037131	1	< 0.1%
-1.583982943	4	0.2%
-1.547594576	2	0.1%
-1.511206209	10	0.5%
-1.474817841	9	0.4%
-1.438429474	11	0.5%
-1.402041107	8	0.4%
-1.36565274	12	0.6%

Value	Count	Frequency (%)
11.69777108	1	< 0.1%
7.731439056	1	< 0.1%
7.076448447	1	< 0.1%
6.967283345	1	< 0.1%
5.329806822	1	< 0.1%
4.929534783	1	< 0.1%
3.947048869	1	< 0.1%
3.910660502	2	0.1%
3.655941931	1	< 0.1%
3.437611728	1	< 0.1%

HIGH_7
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	67
Distinct (%)	3.1%
Missing	40
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	-1.066480654 × 10^-16

Minimum	-0.6043119287
Maximum	20.23051642
Zeros	0
Zeros (%)	0.0%
Negative	1544
Negative (%)	71.1%
Memory size	17.1 KiB

Quantile statistics

Minimum	-0.6043119287
5-th percentile	-0.6043119287
Q1	-0.5133301455
median	-0.3313665791
Q3	0.03256055375
95-th percentile	1.852196218
Maximum	20.23051642
Range	20.83482835
Interquartile range (IQR)	0.5458906992

Descriptive statistics

Standard deviation	1.000234604
Coefficient of variation (CV)	-9.378834959 × 10¹⁵
Kurtosis	88.27369855
Mean	-1.066480654 × 10^-16
Median Absolute Deviation (MAD)	0.1819635664
Skewness	6.462841454
Sum	-2.273736754 × 10^-13
Variance	1.000469263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.5133301455	369	17.0%
-0.4223483623	344	15.8%
-0.3313665791	280	12.9%
-0.2403847959	172	7.9%
-0.6043119287	169	7.8%
-0.1494030127	117	5.4%
-0.05842122946	93	4.3%
0.03256055375	84	3.9%
0.1235423369	58	2.7%
0.2145241202	53	2.4%
Other values (57)	393	18.1%
(Missing)	40	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.6043119287	169	7.8%
-0.5133301455	369	17.0%
-0.4223483623	344	15.8%
-0.3313665791	280	12.9%
-0.2403847959	172	7.9%
-0.1494030127	117	5.4%
-0.05842122946	93	4.3%
0.03256055375	84	3.9%
0.1235423369	58	2.7%
0.2145241202	53	2.4%

Value	Count	Frequency (%)
20.23051642	1	< 0.1%
7.402084993	1	< 0.1%
6.674230728	1	< 0.1%
6.492267161	1	< 0.1%
6.401285378	1	< 0.1%
6.128340028	1	< 0.1%
5.855394679	1	< 0.1%
5.764412896	1	< 0.1%
5.673431112	1	< 0.1%
5.491467546	3	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	ASGS_2016	Houses - median sale price ($)	LF_3	LF_4	HIGH_2	HIGH_3	HIGH_4	HIGH_5	HIGH_6	HIGH_7
0	-1.720801	-1.115756	-0.364926	-1.085680	-0.787026	-0.398054	-0.856490	0.618322	0.634781	-0.455944	-0.513330
1	-1.719271	-1.115756	NaN	-0.576644	-0.644443	-0.161155	-0.563249	0.546349	0.480858	0.380989	-0.240385
2	-1.717742	-1.115756	NaN	-0.207123	-0.501861	0.190809	-0.879047	-0.053434	-0.211795	0.308212	0.123542
3	-1.716212	-1.115756	NaN	-0.833047	-0.558894	0.630765	-0.563249	-0.173390	-0.404198	-0.637885	-0.331367
4	-1.714683	-1.115756	0.117569	-0.361718	-1.157740	0.522468	-0.788819	-0.173390	-0.519640	-1.001769	-0.513330
5	-1.713153	-1.115756	NaN	-0.403195	-1.015157	0.799978	-0.608363	-0.173390	-0.365717	-0.783439	-0.513330
6	-1.711624	-1.115704	NaN	-1.172404	-0.701476	-1.095214	-0.405350	1.134135	1.596798	1.254310	0.123542
7	-1.710094	-1.115704	NaN	-0.821735	-0.644443	-0.858315	-0.585806	0.846240	0.827184	0.308212	-0.240385
8	-1.708565	-1.115704	NaN	-1.134698	-0.929608	-0.533425	-0.630920	0.786262	0.827184	-0.201225	-0.422348
9	-1.707035	-1.115704	NaN	-1.085680	-1.471421	0.184041	-0.427907	0.246457	-0.481159	-0.892604	-0.513330

Last rows

	df_index	ASGS_2016	Houses - median sale price ($)	LF_3	LF_4	HIGH_2	HIGH_3	HIGH_4	HIGH_5	HIGH_6	HIGH_7
2162	1.761945	2.543182	0.318608	-1.146010	-0.729993	1.422684	-1.059503	-0.989094	-0.942928	-0.856216	-0.331367
2163	1.763474	2.543182	NaN	-1.040432	-0.672960	1.903250	-1.510642	-1.540894	-1.712542	-1.438429	-0.513330
2164	1.765004	2.543182	0.336479	-1.149780	-0.644443	1.436221	-0.946718	-0.965103	-0.673563	-0.928992	-0.513330
2165	1.768063	2.543235	NaN	-1.228964	-1.015157	1.835565	-1.217401	-1.420937	-1.597100	-1.656760	-0.513330
2166	1.774181	2.543235	NaN	-1.221422	-1.414388	2.052158	-1.217401	-1.780807	-1.827984	-1.583983	-0.604312
2167	1.775711	2.543287	NaN	-1.334541	-1.357355	0.813515	-0.879047	-0.053434	-1.366216	-1.547595	NaN
2168	1.778770	3.065417	NaN	-1.300606	-1.442904	-1.034297	-0.766262	-0.797164	-1.366216	1.436252	1.215324
2169	1.780299	3.065469	NaN	-1.327000	-0.872575	-0.695870	-0.856490	-1.121046	-0.904447	-0.019283	20.230516
2170	1.781829	3.065521	NaN	-1.311918	0.524732	-0.804166	-0.676034	-0.461286	0.096051	0.162659	0.487469
2171	1.783358	3.065573	NaN	-1.300606	-1.528454	-0.316831	-0.292566	1.110144	0.173012	-1.256488	-0.513330

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows